SongAlbumRecording
Flying Home Concert at the Palladium 182
   "Benny Goodman, The Small Groups 671
   "Jazz Giants of the 20th Century 4943
   "Swing Era, Music of 1941-1942 5287
   "Big Band Jazz 5498
   "Benny Goodman Sextet with Charlie Christian 6263
   "Original Mambo Kings, The 6285
   "All-Time Greatest Hits of Benny Goodman 6455
   "Great Band Era - 12 Band Theme Songs 6670
   "King and Queen of Jazz Piano, The 6922
   "Charlie Barnet 7551
   "Encyclopedia of Jazz on Records - 1940s, The 7923
   "Teddy Wilson 9864
   "Flying Home 11756

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Flying Home"